Skip to main content

Cisco UCM - below v5

These instructions help you configure your Cisco UCM - below v5 phone system to work with TIM Enterprise. Contact your system maintainer if you are not familiar with the configuration of your PBX.

Support files​

Ensure the following support files exist in the /config/ folder of the TIM Enterprise application:

Cisco UCM v4 DSN.TDT
Cisco UCM v4 DSN.TDS
Cisco UCM 4.DBS

Contents​

Configure the SMDR output​

info

You may need to purchase a license to enable SMDR on this PBX. Please speak to your system maintainer if you are unsure.

Follow the instructions below to configure the SMDR output. These instructions are taken from the Cisco UCM - below v5 manual:

This version of the Cisco UCM stores its call records in a Microsoft SQL Server database. However, by default, this functionality is not enabled. To enable it, the following settings must be configured on the Publisher using the Service Parameters configuration window:

  • CDR Enabled
  • CDR Log Calls With Zero Duration Flag
  • Call Diagnostics Enabled

This version of the UCM outputs its call records to a table named CallDetailRecord in a database entitled CDR. Rather than have TIM Enterprise read and remove CDRs from the live CallDetailRecord table, we recommend you replicate this into a second table - leaving the original intact - so that it may be used by other applications that require it. Normally, there already exists a SQL User with the following credentials:

  • Username: CiscoCCMCDR
  • Password: dipsy

To set up replication you may need to speak to your database administrator or your Cisco UCM maintainer. Ensure that the SQL user described above has full access rights to this replicated table. You need to know the following information in order for TIM Enterprise to be able to connect to the Cisco UCM CDR database:

  • The IP address or hostname of the Microsoft SQL Server database located on the Publisher node.
  • The username and password to connect to the CDR database.

Set up a DSN connection​

To enable TIM Enterprise to work with your Cisco UCM, you first need to set up a DSN connection. Follow the steps below to perform this task within Microsoft Windows:

  1. Open Windows Control Panel

  2. Double click on the Administrative tools icon

  3. Double click on the Data Sources (ODBC) icon to open the ODBC Data Source Administrator window

info

For a 64 bit system, access the ODBC Data Source Administrator from the following location C:\Windows\SysWOW64\odbcad32.exe

  1. Select the System DSN tab and click the Add button

  2. Select SQL Server from the list of available drivers and click Finish

  3. In the Name field, enter CCM

  4. In the Description field enter the following: TIM Enterprise link to CCM

  5. In the Database name field enter the database type e.g SQL, MySQL etc.

  6. In the Server drop-down list select the Cisco UCM Publisher IP address or machine name

  7. Click the Next button

  8. Select the option With SQL Server authentication using a login ID and password entered by the user , then click Next

  9. Enable the checkbox Change the default database to: , select CDR , then click the Next button

  10. Click the Finish button

  11. Click the Test Data Source button to verify your settings and, if the test is successful, click OK

  12. Click the OK button to close the control panel applet

An example of an ODBC setup is shown below:

odbc driver

Configure TIM Enterprise​

Once NetPBX is configured and collecting data, log in to TIM Enterprise and perform the following steps:

  1. Click on the Directory tab.

  2. If you don't have a PBX object, press New object and select PBX. Name your site and then select Add. Locate the PBX object you want to configure in the Directory, click on it and select Properties.

  3. A new window will open, displaying the general properties of your PBX object. Select Cisco UCM v4 DSN from the Data format list as shown below:

    TIM Enterprise PBX General Properties

  4. Click on the Connection tab and select No connection required from the Connection method list.

    TIM Enterprise PBX Connection Properties

  5. Click on the Save button to apply the settings.